SELECTdb_name(rsc_dbid) AS ‘DATABASE_NAME’,case rsc_type when 1 then ‘null’when 2 then ‘DATABASE’WHEN 3 THEN ‘FILE’WHEN 4 THEN ‘INDEX’WHEN 5 THEN ‘TABLE’WHEN 6 THEN ‘PAGE’WHEN 7 THEN ‘KEY’WHEN 8 THEN ‘EXTEND’WHEN 9 THEN ‘RID ( ROW ID)’WHEN 10 THEN ‘APPLICATION’ end AS ‘REQUEST_TYPE’, CASE req_ownertype WHEN 1 THEN ‘TRANSACTION’WHEN 2 THEN ‘CURSOR’WHEN 3 THEN ‘SESSION’WHEN 4 THEN … Continue reading Query: Display SQL process (locked record)